PeopleSoft

PeopleSoft Application Update Installation Instructions

This document discusses the contents of this application update, and the events which will occur in your PeopleSoft application environment when the update is applied. The objects delivered in this resolution update may include changes to batch files, data changes, database code revisions and objects, record structures, or PeopleCode. In addition, supplemental documents providing additional information pertaining to this resolution can be found under the <PS_HOME>\maint directory.

This document is intended for the expert technical user who is responsible for applying application changes to your PeopleSoft system. This user should have a basic understanding of PeopleSoft systems and have completed the PeopleSoft Upgrade and Data Management training course. Familiarity with PeopleSoft Upgrade Assistant, PeopleSoft Data Mover, PeopleSoft Application Designer, COBOL compilers, and structure query language (SQL) tools may also be necessary.

For the latest information on updates and fixes for PeopleSoft applications, see Customer Connection, PeopleSoft online information resource. Access Customer Connection through PeopleSoft website at www.peoplesoft.com.

Important!   We recommend that you follow the instructions in the PeopleSoft Application Update Installation Guide when you apply an application update project to your database.  Failure to do so could corrupt your database and cause you to lose customizations that you have made to your database.

General Information on Installing Application Updates

We recommend that you first install this update to your vanilla database (for example, xxDMO) and thoroughly test it before you apply it to your production databases.

We recommend that you run the Upgrade Comparison report against your DMO, test production copy, and production databases to identify any changes delivered in this application update that may impact any customizations that you have made to your databases.

Installing an Update for Applications Using PeopleTools 8.44 and Beyond

To install an application update for applications using PeopleTools 8.44 and beyond, use the Change Assistant with the template provided. After the update has been applied, it is recommended that you delete the Application Server and Process Scheduler Server cache.

Contents of This Update

Update ID: 623989

Subject: 88 to 89 upgrades - SYSAUDIT SEC-05 errors in upgraded database

Description: This update deletes Catalog Management and Partner Registration roles and permission lists to prevent SYSAUDIT errors when upgrading from 8.8/8.8x to 8.9.

DO NOT APPLY THIS UPDATE UNLESS YOU ARE UPGRADING FROM 8.8/8.8x TO 8.9.

This update contains the PRJ610645 project and related files.

Note: Please refer to the excel worksheet that includes a list of the objects and programs that will be modified in this update, as well as a list of records included in this update along with the appropriate actions for each. Note that if there is no X in the update action column for a record, then no build action is required for that record.

Chapter: Apply MetaData Changes

This chapter lists the project that will be applied by Change Assistant to your database using Application Designer. Objects defined in the project are PeopleTools managed objects such as Records, Fields, Pages, Components, PeopleCode, etc.

Task: Apply Project

The following project will be applied to your database. Please refer to the Implementation section of the update resolution on Customer Connection or the modified objects list included in the documentation for this update.

PRJ610645

Step: Compare Project with Source Database

First step in the migration of a PeopleSoft-delivered change package to your environments. PeopleSoft Change Assistant runs a compare report of the project between a PeopleSoft demo database that contains this project and your target database.

Manual Step: Examine Compare Report

After the project compare completes, examine the report and decide whether or not to accept the object change.

1. Using Application Designer, modify the actions for each of the objects in the source database.

2. Within PeopleSoft Change Assistant, mark this step Complete or you cannot continue with the migration process.

Note: PeopleSoft does not support the addition or removal of objects through the migration process.

Step: Copy Project From Source Database

PeopleSoft Change Assistant copies the project from your source database to your target database, based on the object actions you specified in the previous step.

Step: Extract Change Package

Peoplesoft Change Assistant extracts the change package to a temporary directory in your staging directory (~ExtractedCP).

Manual Step: Re-Apply Your Customizations

After the project has been copied to your target database, re-apply your customizations in your target database using Application Designer.

Step: Export Project From Target Database

PeopleSoft Change Assistant exports the project, including your customizations, from the target database to a temporary directory in the staging directory (~ExportedProject).

Step: Create Modified Change Package

PeopleSoft Change Assistant creates a modified change package that includes your customizations.

Step: Copy Update Project

This step will update your PeopleSoft object definitions.

Chapter: Execute File References

This chapter lists the program(s) or script(s) that will be executed against your database.

Task: Execute Data Mover script(s)

Change Assistant will execute the following Data Mover script(s) against your database:

upd610645_01.dms

upd610645_02.dms

Chapter: Deploy Files

This chapter lists files in the Change Package that were 'File Reference' objects marked for deploy. The files will be copied into the locations that are associated with their corresponding File Type Codes on your database. The chapter also lists the COBOL files which should be deployed and compiled, if there are any.

Task: File Type Code: MAINT

Change Assistant will deploy the following files to the appropriate PeopleSoft server(s):

upd610645_01.dms

upd610645_02.dms

Task: Copy File(s) For OS390

You must manually FTP files included in this Change Package from your batch or file server to the OS/390 PDS. Here are the PDS file locations based on type of file:

ASM files go into $PSHLQ$.SRCLIB

CBL(which are not copy lib) files go into $PSHLQ$.SRCLIB

CBL (which are copy lib) files go into $PSHLQ$.COPYLIB

SQL files go to $PSHLQ$.DDLLIB

JCL files go to $PSHLQ$.JCLLIB

PRC files go to $PSHLQ$.PROCLIB

SQR files go to $PSHLQ$.SQRSRC

SQC files go to $PSHLQ$.SQRINC

PAR files go to $PSHLQ$.PARMLIB

Chapter/Task: Update Package Prerequisites

Prerequisite information is retrieved from the Change Package and Project prerequisites are updated in your database.